package com.zhq.blog.core.domain.game.support;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.zhq.blog.core.domain.BaseRepository;

/**
 * @title:OddsRepository.java
 * @package com.zhq.blog.core.domain.game.support
 * @author 张恒强
 * @date 2014年12月27日 上午11:51:00
 * @version V1.0
 */
public interface OddsRepository extends JpaRepository<Odds,Long>,
				BaseRepository<Odds>,JpaSpecificationExecutor<Odds>{
	
	@Query("select o from Odds o where o.deleted = 0 and o.gameId = :gameId order by number asc")
	List<Odds> find_all_by_game(@Param("gameId") long gameId);

}
